﻿USE KwaiXiaoDianDB;
GO

--商品表添加月销量浏览量和推广达人数等字段
if not exists(select * from syscolumns where id=object_id('t_product') and name='total_order_num')
begin
	ALTER TABLE dbo.t_product ADD total_order_num INT NULL;
END
GO

if not exists(select * from syscolumns where id=object_id('t_product') and name='total_pv')
begin
	ALTER TABLE dbo.t_product ADD total_pv INT NULL;
END
GO

if not exists(select * from syscolumns where id=object_id('t_product') and name='total_promoter_num')
begin
	ALTER TABLE dbo.t_product ADD total_promoter_num INT NULL;
END
GO